import pandas as pd
import openpyxl

way_station = {
    "西康方向": {"安康": 0, "镇安": 0, "旬阳": 0, "安康其他区域": 0},
    "西宝方向": {"咸阳": 0, "杨陵": 0, "蔡家坡（岐山）": 0, "宝鸡": 0, "宝鸡其他区域": 0},
    "西平方向": {"礼泉": 0, "乾县": 0, "永寿": 0, "郴州": 0, "长武": 0},
    "汉中方向": {"鄠邑": 0, "佛坪": 0, "洋县": 0, "城固": 0, "汉中": 0, "宁强": 0, "略阳": 0, "汉中其他区域": 0},
    "东孟方向": {"渭南": 0, "大荔": 0, "韩城": 0, "合阳": 0, "富平": 0, "韦庄": 0, "丹凤": 0, "商南": 0, "商洛": 0, "东孟其他方向": 0},
    "陕北方向": {"蒲城": 0, "洛川": 0, "黄陵": 0, "富县": 0, "延安": 0, "子长": 0, "清涧县": 0, "绥德": 0, "米脂": 0, "榆林": 0, "神木": 0,
             "陕北其他方向": 0},
    "京津方向": {"北京": 0, "天津": 0, "石家庄": 0, "保定": 0, "邯郸": 0, "唐山": 0, "京津其他区域": 0},
    "沪杭方向": {"上海": 0, "杭州": 0, "宁波": 0, "合肥": 0, "芜湖": 0, "巢湖": 0, "徐州": 0, "苏州": 0, "无锡": 0, "南通": 0, "阜阳": 0, "泰州": 0,
             "宿州": 0, "扬州": 0, "蚌埠": 0, "沪杭其他区域": 0},
    "山西方向": {"运城": 0, "临汾": 0, "侯马": 0, "太原": 0, "大同": 0, "山西其他区域": 0},
    "广深方向": {"武汉": 0, "长沙": 0, "衡阳": 0, "广州": 0, "深圳": 0, "广深其他区域": 0},
    "河南方向": {"郑州": 0, "洛阳": 0, "商丘": 0, "信阳": 0, "南阳": 0, "新乡": 0, "安阳": 0, "三门峡": 0, "河南其他区域": 0},
    "兰新方向": {"天水": 0, "定西": 0, "兰州": 0, "酒泉": 0, "吐鲁番": 0, "哈密": 0, "乌鲁木齐": 0, "库尔勒": 0, "奎屯": 0, "喀什": 0, "兰新其他区域": 0},
    "四川方向": {"广元": 0, "绵阳": 0, "德阳": 0, "成都": 0, "重庆": 0, "达州": 0, "南充": 0, "万源": 0, "四川其他区域": 0},
    "江西福建": {"南昌": 0, "九江": 0, "鹰潭": 0, "宜春": 0, "福州": 0, "厦门": 0, "抚州": 0, "赣州": 0, "江 西、福建其他区域": 0},
    "胶东方向": {"菏泽": 0, "济宁": 0, "济南": 0, "青岛": 0, "威海": 0, "烟台": 0, "连云港": 0, "胶东其他区域": 0},
    "银川方向": {"平凉": 0, "固原": 0, "中卫": 0, "中宁": 0, "庆阳": 0, "银川": 0, "银川其他区域": 0},
    "东北方向": {"四平": 0, "长春": 0, "锦州": 0, "哈尔滨": 0, "吉林": 0, "佳木斯": 0, "大连": 0, "沈阳": 0, "东北其他区域": 0},
    "内蒙方向": {"包头": 0, "呼和浩特": 0, "鄂尔多斯": 0, "临河": 0, "乌海": 0, "集宁": 0, "内蒙其他区域": 0},
    "青海方向": {"西宁": 0, "格尔木": 0, "拉萨": 0, "海东": 0, "青海其他区域": 0},
    "湖北方向": {"宜昌": 0, "十堰": 0, "襄阳": 0, "荆门": 0, "武昌": 0, "汉口": 0, "孝感": 0, "湖北其他区域": 0},
    "云贵方向": {"遵义": 0, "贵阳": 0, "昆明": 0, "云贵其他区域": 0},
    "广西方向": {"桂林": 0, "南宁": 0, "广西其他区域": 0},
}


table = {
    "安康": 'C3', "镇安": 'C4', "旬阳": 'C5', "安康其他区域": 'C6',
    "咸阳": 'C7', "杨陵": 'C8', "蔡家坡（岐山）": 'C9', "宝鸡": 'C10', "宝鸡其他区域": 'C11',
    "礼泉": 'C12', "乾县": 'C13', "永寿": 'C14', "郴州": 'C15', "长武": 'C16',
    "鄠邑": 'C17', "佛坪": 'C18', "洋县": 'C19', "城固": 'C20', "汉中": 'C21', "宁强": 'C22', "略阳": 'C23', "汉中其他区域": 'C24',
    "渭南": 'C25', "大荔": 'C26', "韩城": 'C27', "合阳": 'C28', "富平": 'C29', "韦庄": 'C30', "丹凤": 'C31', "商南": 'C32', "商洛": 'C33', "东孟其他方向": 'C34',
    "蒲城": 'C35', "洛川": 'C36', "黄陵": 'C37', "富县": 'C38', "延安": 'C39', "子长": 'C40', "清涧县": 'C41', "绥德": 'C42', "米脂": 'C43', "榆林": 'C44', "神木": 'C45', "陕北其他方向": 'C46',
    "北京": 'F3', "天津": 'F4', "石家庄": 'F5', "保定": 'F6', "邯郸": 'F7', "唐山": 'F8', "京津其他区域": 'F9',
    "上海": 'F10', "杭州": 'F11', "宁波": 'F12', "合肥": 'F13', "芜湖": 'F14', "巢湖": 'F15', "徐州": 'F16', "苏州": 'F17', "无锡": 'F18', "南通": 'F19', "阜阳": 'F20', "泰州": 'F21', "宿州": 'F22',
    "扬州": 'F23', "蚌埠": 'F24', "沪杭其他区域": 'F25',
    "运城": 'F26', "临汾": 'F27', "侯马": 'F28', "太原": 'F29', "大同": 'F30', "山西其他区域": 'F31',
    "武汉": 'F32', "长沙": 'F33', "衡阳": 'F34', "广州": 'F35', "深圳": 'F36', "广深其他区域": 'F37',
    "郑州": 'F38', "洛阳": 'F39', "商丘": 'F40', "信阳": 'F41', "南阳": 'F42', "新乡": 'F43', "安阳": 'F44', "三门峡": 'F45', "河南其他区域": 'F46',
    "天水": 'I3', "定西": 'I4', "兰州": 'I5', "酒泉": 'I6', "吐鲁番": 'I7', "哈密": 'I8', "乌鲁木齐": 'I9', "库尔勒": 'I10', "奎屯": 'I11', "喀什": 'I12', "兰新其他区域": 'I13',
    "广元": 'I14', "绵阳": 'I15', "德阳": 'I16', "成都": 'I17', "重庆": 'I18', "达州": 'I19', "南充": 'I20', "万源": 'I21', "四川其他区域": 'I22',
    "南昌": 'I23', "九江": 'I24', "鹰潭": 'I25', "宜春": 'I26', "福州": 'I27', "厦门": 'I28', "抚州": 'I29', "赣州": 'I30', "江西、福建其他区域": 'I31',
    "菏泽": 'I32', "济宁": 'I33', "济南": 'I34', "青岛": 'I35', "威海": 'I36', "烟台": 'I37', "连云港": 'I38', "胶东其他区域": 'I39',
    "平凉": 'I40', "固原": 'I41', "中卫": 'I42', "中宁": 'I43', "庆阳": 'I44', "银川": 'I45', "银川其他区域": 'I46',
    "四平": 'L3', "长春": 'L4', "锦州": 'L5', "哈尔滨": 'L6', "吉林": 'L7', "佳木斯": 'L8', "大连": 'L9', "沈阳": 'L10', "东北其他区域": 'L11',
    "包头": 'L12', "呼和浩特": 'L13', "鄂尔多斯": 'L14', "临河": 'L15', "乌海": 'L16', "集宁": 'L17', "内蒙其他区域": 'L18',
    "西宁": 'L19', "格尔木": 'L20', "拉萨": 'L21', "海东": 'L22', "青海其他区域": 'L23',
    "宜昌": 'L24', "十堰": 'L25', "襄阳": 'L26', "荆门": 'L27', "武昌": 'L28', "汉口": 'L29', "孝感": 'L30', "湖北其他区域": 'L31',
    "遵义": 'L32', "贵阳": 'L33', "昆明": 'L34', "云贵其他区域": 'L35',
    "桂林": 'L36', "南宁": 'L37', "广西其他区域": 'L38',
}
